﻿SET QUOTED_IDENTIFIER ON
GO
SET ARITHABORT ON
GO
SET NUMERIC_ROUNDABORT OFF
GO
SET CONCAT_NULL_YIELDS_NULL ON
GO
SET ANSI_NULLS ON
GO
SET ANSI_PADDING ON
GO
SET ANSI_WARNINGS ON
GO

CREATE PROCEDURE [dbo].[bhp_NemoGroupSystemNamesGet]
AS
BEGIN
	
	
	SELECT
		id as GroupId,
		name as SystemName
	FROM
		sTree
	WHERE
		del = 0
		AND typ = 'T'

END
